Starts with operator

Basic and Crystal syntax.

The startsWith operator is useful for selecting records to include or exclude from your report.

Usage

x startsWith y

{fieldname} startsWith "abc"

This operator tests to see if the contents of {fieldname} start with a character string that you specify: "abc". If the contents of the field do start with "abc", then the formula returns the value True. If the field starts with anything else, the formula returns False.

Examples

The following examples are applicable to both Basic and Crystal syntax:

{customer.CUSTOMER NAME} startsWith "A"

TRUE, where {customer.CUSTOMER NAME} = ABC Ltd.

{customer.CUSTOMER NAME} startsWith "C"

FALSE, where {customer.CUSTOMER NAME} = ABC Ltd.

{customer.CUSTOMER NAME} startsWith "ABC"

TRUE, where {customer.CUSTOMER NAME} = ABC Inc. or ABC Ltd.

{customer.CUSTOMER NAME} startsWith "ABC"

FALSE, where {customer.CUSTOMER NAME} = XYZ Inc.



Seagate Software IMG Holdings, Inc.
http://www.seagatesoftware.com
Support services:
http://support.seagatesoftware.com